-- SOME TEST DATA FOR CRICKET SCHEMA

-- TEAMS
select 'INSERT INTO cricket.Teams (' + cast(TeamId as varchar) + ', ' +char(39)+ TeamName +char(39)+ ', ' 
									+char(39)+ isnull(cast(CaptainId as varchar), 'NULL') +char(39)+ ', ' 
									+char(39)+ isnull(cast(ViceCaptainId as varchar), 'NULL') +char(39)+ ')'
from cricket.Teams

-- SEASONS
select 'INSERT INTO cricket.Seasons (' + cast(SeasonId as varchar) + ', '+char(39)+ SeasonName +char(39)+', ' 
									+char(39)+ isnull(convert(varchar, SeasonStart, 103), 'NULL') +char(39)+ ', ' 
									+char(39)+ isnull(convert(varchar, SeasonEnd, 103), 'NULL') +char(39)+ ')'
from cricket.seasons

-- PLAYERSTATS
